from django.db import models


class User(models.Model):
    id = models.IntegerField(primary_key=True)
    username = models.CharField(max_length=50, null=False, unique=True)
    password = models.CharField(max_length=16, null=False)
    SCKEY_ID = models.IntegerField()

    class Meta:
        db_table = 'user'


class Ex_info(models.Model):
    id = models.IntegerField(primary_key=True)
    user_id = models.IntegerField(null=False)
    start_airport = models.CharField(max_length=50, null=False)
    end_airport = models.CharField(max_length=50, null=False)
    start_time = models.DateTimeField(null=False)
    price = models.FloatField(default=1000000)

    class Meta:
        db_table = 'expected_info'
